From 31c7177d75734a7dfbed9a17971ec24fb2858125 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 15:10:26 +0000 Subject: [PATCH] Use DepartDate, not EntryDate, when checking community departure --- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index e080b8d..0e5c756 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -400,7 +400,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () -- An individual may not be placed in a community after the -- individual left the study. IF TG_OP = 'UPDATE' - AND NEW.entrydate <> OLD.entrydate THEN + AND NEW.departdate < OLD.departdate THEN DECLARE commmid comm_membs.commmid%TYPE; enddate comm_membs.enddate%TYPE; -- 2.34.1